<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">
    

    <title>Panel de control de SomXarxaApp</title>

    <!-- Bootstrap core CSS -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="css/dashboard.css" rel="stylesheet">

    <!-- Just for debugging purposes. Don't actually copy this line! -->
    <!--[if lt IE 9]><script src="../../assets/js/ie8-responsive-file-warning.js"></script><![endif]-->

    <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
      <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>

  <body>

    <div class="navbar navbar-inverse navbar-fixed-top" role="navigation">
      <div class="container-fluid">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="#">SomXarxa App Ayuntamientos</a>
        </div>
        <div class="navbar-collapse collapse">
          <ul class="nav navbar-nav navbar-right">
            <li><a href="#">Dashboard</a></li>
            <li><a href="#">Settings</a></li>
            <li><a href="#">Profile</a></li>
            <li><a href="#">Help</a></li>
          </ul>
          <form class="navbar-form navbar-right">
            <input type="text" class="form-control" placeholder="Search...">
          </form>
        </div>
      </div>
    </div>

    <div class="container-fluid">
      <div class="row">
        <div class="col-sm-3 col-md-2 sidebar">
          <ul class="nav nav-sidebar">
            <li class="active"><a href="#" class="menuLateral" data-seccion="overview" data-filtro="seccion">Overview</a></li>
            <li><a href="#" class="menuLateral" data-seccion="reports" data-filtro="seccion">Reports</a></li>
            <li><a href="#" class="menuLateral" data-seccion="analytics" data-filtro="seccion">Analytics</a></li>
            <li><a href="#" class="menuLateral" data-seccion="export" data-filtro="seccion">Export</a></li>
          </ul>
          <ul class="nav nav-sidebar">
            <li><a href="#" class="menuLateral" data-seccion="alertas" data-filtro="seccion">Alertas</a></li>
            <li><a href="#" class="menuLateral" data-seccion="noticias" data-filtro="seccion">Noticias</a></li>
            <li><a href="#" class="menuLateral" data-seccion="eventos" data-filtro="seccion">Eventos</a></li>
            <li><a href="#" class="menuLateral" data-seccion="incidencias" data-filtro="seccion">Incidencias</a></li>            
          </ul>
          <ul class="nav nav-sidebar">
            <li><a href="#" class="menuLateral" data-seccion="usuarios" data-filtro="seccion">Usuarios</a></li>
            <li><a href="#" class="menuLateral" data-seccion="departamentos" data-filtro="seccion">Departamentos</a></li>
            <li><a href="#" class="menuLateral" data-seccion="categorias" data-filtro="seccion">Categor&iacute;as</a></li>
          </ul>
        </div>
        <div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">          
          <h1 class="page-header">Dashboard</h1>
          <div>
            <?php include ("include/conex.php");

              $sql=mysql_query("SELECT * FROM Idioma_Locale"); 
            ?>

          </div>
          <div class="row placeholders">
            <div class="col-xs-6 col-sm-3 placeholder">
              <img data-src="holder.js/200x200/auto/sky" class="img-responsive" alt="Generic placeholder thumbnail">
              <h4>Label</h4>
              <span class="text-muted">Something else</span>
            </div>
            <div class="col-xs-6 col-sm-3 placeholder">
              <img data-src="holder.js/200x200/auto/vine" class="img-responsive" alt="Generic placeholder thumbnail">
              <h4>Label</h4>
              <span class="text-muted">Something else</span>
            </div>
            <div class="col-xs-6 col-sm-3 placeholder">
              <img data-src="holder.js/200x200/auto/sky" class="img-responsive" alt="Generic placeholder thumbnail">
              <h4>Label</h4>
              <span class="text-muted">Something else</span>
            </div>
            <div class="col-xs-6 col-sm-3 placeholder">
              <img data-src="holder.js/200x200/auto/vine" class="img-responsive" alt="Generic placeholder thumbnail">
              <h4>Label</h4>
              <span class="text-muted">Something else</span>
            </div>
          </div>

          <h2 class="sub-header">Section title</h2>
          <div class="table-responsive">
            <table class="table table-striped">
              <thead>
                <tr>
                  <th>id</th>
                  <th>id_idioma</th>
                  <th>Locale</th>
                  <th>Nombre</th>                  
                </tr>
              </thead>
              <tbody>
                <?php while($res=mysql_fetch_array($sql)){
                  $id_idioma=$res['id_idioma'];
                  $sql2=mysql_query("SELECT locale FROM Idioma WHERE id=$id_idioma LIMIT 1")?>
                <tr>
                  <td><?php echo $res['id']?></td>
                  <td><?php echo $res['id_idioma']?></td>                  
                  <td><?php echo mysql_result($sql2, 0)?></td>                  
                  <td><?php echo $res['nombre']?></td>
                </tr>          
                <?php };?>
                
              </tbody>
            </table>
          </div> <!-- Fin tabla -->
        </div> <!-- Fin main -->
      </div> <!-- Fin row -->
    </div><!-- Fin contenedor -->

    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
    <script src="js/bootstrap.min.js"></script>    
    <script src="js/docs.min.js"></script>    
    <script src="js/comun.js"></script>    
  </body>
</html>